To Manually Reconcile your Bank Statement using the E Reconcile Option

Select a date in both the Bank Transactions To and Sage Transactions To boxes to filter the transactions that are displayed.

If the transaction is a payment, the amount is displayed here.

This displays the transaction number in your bank account. Tran No displays the transaction number in your Sage Line 50 program.

If the transaction is a receipt, the amount is displayed here.

This displays the transaction reference code that has been entered for both your bank and Sage Line 50 transactions.

When a transaction has been matched, this displays the transaction(s) that was matched against it.

In the list of Sage Line 50 transactions there is an additional list labelled æTypeÆ. This displays the type of transaction. For example BP represents a Bank Payment, SR represents a sales receipt and JC represents a Journal Credit. For a complete list of bank transaction types, see Bank Transaction Types.

This shows if the transaction has been confirmed. Initially set to æNÆ, once the transaction has been confirmed, the field will change to æYÆ.

This shows the date that the transaction was entered onto the system. Note: In Sage Line 50 you can set the program date to a day other than todayÆs date so that a specified date appears on any entered transactions. Therefore some of the Sage transactions may not correspond to the actual day that they were created.

This shows the amount matched against the transaction.

This displays any additional details that were entered when the transaction was created.

This is the statement balance brought forward from the last reconciliation. It should reflect the opening balance on the statement.

Shows the value of the unreconciled transactions in your Sage Line 50 program.

This is the balance of the bank account up to the date entered on the bank reconciliation screen and represents the balance as if all transactions have been cleared.

This box initially shows the Opening Balance figure, but then changes automatically by the value of the transactions you select for reconciliation. As you work through your bank statement reconciling each line, this value should change to match the balance shown by your bank statement. Before you save the reconciliation, this box should show the same balance as the closing balance of your bank statement. If it does not, the opening balance on your next reconciliation will be incorrect.

When you enter the closing balance of your actual bank statement, the Difference box shows the difference between the transactions you have selected for reconciliation and the Statement End. Balance. When you have selected all of your transactions, this displays a zero balance unless you have adjustments to make, e.g. bank charges or interest payments.

Shows the balance from your imported bank statement. You can change this amount from the Amend Bank Statement Details Window.

Note: The process depends on whether the Automatically Confirm Manual Matches is checked. The following process describes the routine with the default settings. For more information see To Set Up the E Reconciliation Options.

3. Enter the Statement End Date and Statement End Balance details in the relevant boxes, then click OK.

4. From either the Sage Line 50 transaction list or Bank transaction list, select the transaction that you wish to reconcile.

5. From the opposite list select the transaction or transactions that you want to reconcile against the transaction selected in step 3.

Note: If the Automatically Confirm Manual Matches check box is checked (the default setting), the Match Manual button will confirm the transactions.

If the check box is unchecked, the transactions will be highlighted in green. You must confirm the transactions again by clicking Confirm before you reconcile the transactions. For more information see To Set Up the E Reconciliation Options.

You can view your confirmed transactions by selecting View from the option bar and then choosing Confirmed. Only your confirmed transactions will appear. Alternatively, you can view every transaction by selecting the View All option.

7. To finish the reconciliation routine, click Reconcile. Alternatively, if you want to exit without reconciling or saving any matched transactions, click Discard.

8. Click Yes to reconcile the matched transactions. Click No to stop the reconciliation process and return to the Reconciliation window.

The matched transactions are marked as reconciled in the Bank module and will no longer appear in the list of Sage or bank transactions. If you have accidentally reconciled a transaction in the bank list, it is possible to reverse the reconciliation process so the transaction appears in your bank list by using the Amend bank Transactions option. For more information see Amending Bank Transactions.

(Bank Transactions/Sage Transactions) To	Payments
No (Tran No.)	Receipts
Ref	Match With
Type	Conf?
Date	Rec Amount
Details

Opening Balance	Uncleared Items
Book Balance at Date	Reconciled Balance
Difference	Statement End Balance